package junghoAndI;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class OracleJDBC {
	private static final String DRV = "oracle.jdbc.OracleDriver";
	private static final String URL = "jdbc:oracle:thin:@//112.216.253.122:1521/xe";
	private static final String USR = "booroo83";
	private static final String PWD = "booroo83";
	
	
	public static Connection openConn(){
		Connection conn = null;
		try{
			Class.forName(DRV);
			conn = DriverManager.getConnection(URL, USR, PWD);
		} catch(Exception ex){
			ex.printStackTrace();
		}
		return conn;
		
	}
	
	
	public static void closeConn(Connection c,PreparedStatement p,ResultSet r){
		if(r!=null)
			try{r.close();}catch(Exception e){}
		if(p!=null)
			try{p.close();}catch(Exception e){}
		if(c!=null)
			try{c.close();}catch(Exception e){}
	}
	
}
